home *** CD-ROM | disk | FTP | other *** search
/ Delphi Magazine Collection 2001 / Delphi Magazine Collection 20001 (2001).iso / DISKS / ISSUE10 / CLINIC / GRIDFITU.PAS < prev    next >
Encoding:
Pascal/Delphi Source File  |  1996-04-20  |  946 b   |  50 lines
  1. unit GridFitU;
  2.  
  3. interface
  4.  
  5. uses
  6.   WinProcs, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  7.   DB, DBTables, Grids, DBGrids, StdCtrls, OptGridU;
  8.  
  9. type
  10.   TForm1 = class(TForm)
  11.     Memo1: TMemo;
  12.     DataSource1: TDataSource;
  13.     Query1: TQuery;
  14.     DBGrid1: TDBOptGrid;
  15.     procedure DBGrid1DblClick(Sender: TObject);
  16.     procedure Query1AfterOpen(DataSet: TDataSet);
  17.     procedure FormCreate(Sender: TObject);
  18.   end;
  19.  
  20. var
  21.   Form1: TForm1;
  22.  
  23. implementation
  24.  
  25. {$R *.DFM}
  26.  
  27. procedure TForm1.DBGrid1DblClick(Sender: TObject);
  28. begin
  29.   Query1.SQL := Memo1.Lines;
  30.   try
  31.     Query1.Open;
  32.   except
  33.     Query1.SQL.Clear;
  34.   end;
  35. end;
  36.  
  37. procedure TForm1.Query1AfterOpen(DataSet: TDataSet);
  38. begin
  39.   DBGrid1.Width:= DBGrid1.OptWidth;
  40. end;
  41.  
  42. procedure TForm1.FormCreate(Sender: TObject);
  43. begin
  44.   { Ensure grid has set its columns up first }
  45.   DBGrid1.Perform(wm_Paint, 0, 0);
  46.   Query1.Open;
  47. end;
  48.  
  49. end.
  50.